# -*- coding: utf-8 -*-
# @Time    : 2024/12/9  15:36
# @Author  : Nabby
# @FileName: jasco_forecast_information.py
# @Desc    : 货物预报信息


from app import db, loginmanager
from datetime import datetime


class JascoFileManage(db.Model):
    __tablename__ = 'jasco_file_manage'
    id = db.Column(db.Integer, primary_key=True)
    type = db.Column(db.String(20), comment='文件类型')
    file_name = db.Column(db.String(50), comment='文件名')
    source = db.Column(db.String(50), comment='来源')
    remark = db.Column(db.String(100), comment='备注')
    file_path = db.Column(db.String(100), comment='文件路径')
    order_id = db.Column(db.Integer, db.ForeignKey('jasco_order.id'), comment='订单id')
    create_time = db.Column(db.DateTime, default=datetime.now)
    update_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)
    etd = db.Column(db.DateTime, default=datetime.now)
    pol = db.Column(db.String(50), comment='起运港口')
    company_name = db.Column(db.String(50), comment='公司名称')
    linkman = db.Column(db.String(20), comment='联系人')
    phone = db.Column(db.String(20), comment='电话')
    email = db.Column(db.String(50), comment='邮箱')
    invoice_number = db.Column(db.String(50), comment='发票号码')
    goods_name = db.Column(db.String(50), comment='发货品名')
    loading_time = db.Column(db.DateTime, comment='装货时间')
    total_packages = db.Column(db.String(20), comment='总件数')
    total_weight = db.Column(db.String(20), comment='总毛重')
    total_volume = db.Column(db.String(20), comment='总体积')
    atd = db.Column(db.DateTime, comment='实际船开时间')
    actual_pol = db.Column(db.String(50), comment='实际起运港口')
    eta = db.Column(db.DateTime, comment='预计到达时间')
    pod = db.Column(db.String(50), comment='预计到达港口')
    vel = db.Column(db.String(50), comment='船名航次')
    mbl = db.Column(db.String(50), comment='MBL单号')
    hbl = db.Column(db.String(50), comment='HBL单号')
    deliver_to = db.Column(db.String(50), comment='送货地址')
    terms = db.Column(db.String(100), comment='条款')





